﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Common.FileManagement
{
    public struct DbStoredProceduresFileManagement
    {

        #region FILEMANAGEMENT
        public const string FILEMANAGEMENT_SEARCHFILE = "[dbo].[usp.Core.FileManager.File]";
        public const string FILEMANAGEMENT_UPDATEFILE = "[dbo].[usp.Core.FileManager.UpdateFile]";
        public const string FILEMANAGEMENT_DELETEFILE = "[dbo].[usp.Core.FileManager.DeleteFile]";
        public const string FILEMANAGEMENT_GETFILE = "[dbo].[usp.Core.FileManager.GetFile]";
        public const string FILEMANAGEMENT_GETFILETYPE = "[dbo].[usp.Core.FileManager.GetFileType]";
        public const string FILEMANAGEMENT_GETCOREUSER = "[dbo].[usp.Core.GetUser]";
        public const string FILEMANAGEMENT_GETDOCTYPE = "[dbo].[usp.Core.FileManager.GetDocumentType]";

       

         #endregion
    }
    public struct DbColumnNameFileManagement
    {
        #region FILE
        public const string FILEID = "Id";
        public const string SOURCEFILENAME = "Subject";
        public const string SOURCEFILEPATH = "Detail";    
        public const string FILENAME = "FileName";
        public const string NOTE = "Note";
        public const string DOCUMENTTYPEID = "DocumentTypeId";
        public const string UserId = "UserId";
        public const string ORIGINALFILEPATH = "OriginalFilePath";


        public const string FILECONTENT = "FileContent";
        public const string FILECREATEDBY = "CreatedBy";
        public const string FILECREATEDON = "CreatedOn"; 

                            
        #endregion

        #region COREUSER
        public const string USERID = "Id";
        public const string LOGINID = "LoginId";
        public const string CITY = "City";
        #endregion

        #region FILETYPE

        public const string FILETYPENAME = "Name";
        public const string DISPLAYORDER = "DisplayOrder";
        public const string MIMETYPE = "MimeType";
        #endregion
    }
     public struct DbFileParameters
    {       
        public const string PRID = "@Id";
        public const string PRPATIENTID = "@PatientId";
        public const string PRFILENAME = "@FileName";
        public const string PRORIGINLAFILENAME = "@OrigionalFileName";
        public const string PRORIGINALFILEPATH = "@OrigionalFilePath";
        public const string PRFILETYPEID = "@FileTypeId";
        public const string PRDOCTYPEID = "@DocumentTypeId";
        public const string PRRECORDID = "@RecordId";
        public const string PRCONTENTID = "@FileContent";
        public const string PRNOTE = "@Note";
        public const string PRNOTIFYTO = "@NotifyTo";
        
    }


    
}
